package com.infosys.newSimpleInvertedIndex.mapper;

import com.infosys.newSimpleInvertedIndex.entities.Employee;
import com.infosys.newSimpleInvertedIndex.entities.Relative;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * <p>
 * 员工关系表 Mapper 接口
 * </p>
 *
 * @author Tester
 * @since 2024-06-24
 */
@Mapper
public interface RelativeMapper extends BaseMapper<Relative> {
    @Select( "SELECT * FROM relative WHERE employee_id = #{employeeId}" )
    Relative getRelativesByEmployeeId(@Param("employeeId") String id);
}